<%
Response.Cache.SetCacheability(System.Web.HttpCacheability.NoCache);
%>
//Copyright (C) 2000-2002 i-Global Solutions Ltd. All Rights Reserved
<%@ Import Namespace="Muki.Framework" %>
<%@ Import Namespace="Muki.Util" %>

<script Language="C#" runat="server">
private string cUSQL_CODE = "";
private string cUID_CODE  = "";
private string cGETX_CODE	= "";
private string cREFX_CODE = "";
private ZZSQLStatement objZZSQLStatement;
public ZZQLite objZZQLite=new ZZQLite();

void Page_Load(Object sender , EventArgs e)
{
	cUSQL_CODE= ZZGeneral.XRequest("USQL_CODE");
	cUID_CODE = ZZGeneral.XRequest("UID_CODE");
	cGETX_CODE= ZZGeneral.XRequest("GETX_CODE");
	cREFX_CODE= ZZGeneral.XRequest("REFX_CODE");

  objZZSQLStatement=new ZZSQLStatement();
	
	objZZSQLStatement.UID_CODE=cUID_CODE;

	objZZSQLStatement.SQLStatement(cUSQL_CODE);
	
	objZZQLite=objZZSQLStatement.oZZQLite;
	
	//if (cCOLUMN_NAME1!="") objZZQLite.AddSimpleWhereClause("",cCOLUMN_NAME1,cCOLUMN_VALUE1,CLAUSE_OPERATOR.CLAUSE_LIKE);
	//if (cCOLUMN_NAME2!="") objZZQLite.AddSimpleWhereClause("",cCOLUMN_NAME2,cCOLUMN_VALUE2,CLAUSE_OPERATOR.CLAUSE_LIKE);
	//if (cCOLUMN_NAME3!="") objZZQLite.AddSimpleWhereClause("",cCOLUMN_NAME3,cCOLUMN_VALUE3,CLAUSE_OPERATOR.CLAUSE_LIKE);

	objZZQLite.Make();

	Response.Write(objZZQLite.SQLStatement);

}
</script>

